Updating Source Extract SQL

You can keep a record of multiple source extract SQL and its description. You can also update it as per your requirements.

To update source extract SQL, follow these steps:

  1. In the Additional Mapping Information pane, click the Source Extract SQL tab.

    2. The Source Extract SQL tab appears.

    Source Extract Sql
  2. click Icon Edit Roles.
    3. Source Extract Sql Update
  3. Enter SQL Query and SQL Query Description.

    4. For example:

    • SQL Query: Select * from dbo.RM_Resource
    • SQL Query Description: - The query extracts the data from dbo.RM_Resource table.
  4. Click Icon Save User.

    5. The Source Extract SQL is updated.